home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgLangD.iso / Foxpro 2.6 {Windows} / CHARGES.QP_ / CHARGES.bin
Text File  |  1994-03-10  |  381b  |  11 lines

  1. SELECT Credcard.card_id, Credcard.startbal, Credcard.baldate,;
  2.   Details.trans_type, Details.trans_date, Details.amt, Credcard.type;
  3.  FROM Credcard, Details;
  4.  WHERE Details.card_id = Credcard.card_id;
  5.    AND Details.trans_date > Credcard.baldate;
  6.    AND Credcard.card_id = "    ";
  7.  ORDER BY Credcard.card_id;
  8.  INTO CURSOR CHARGES
  9. REPORT FORM REPORTS\CHARGES.FRX PREVIEW
  10.  
  11.